Aeroallergens Database Design

The increasing need for the daily report of aeroallergens and in an effort to bring computer engineering technology into aerobiology, this project focuses on integrating computer engineering solutions with aerobiology to streamline and facilitate easy storage, manipulation and retrieval of data related to aeroallergens studies by developing an intuitive and easy to use computer application. Currently in Puerto Rico, we are in charge of two stations in San Juan and Caguas, to report the daily fungal spores and pollen counts to the American Academy of Allergy, Asthma & Immunology. Currently, these stations rely on manual laboratory counters to make accurate spore counts and maintain this data in Excel format with very limited functionality. In this project, we developed a database and its related software application to replace this tedious manual process with a reliable and feature packed software. The aim is to enhance and facilitate the recording and reporting of fungal spores and pollens by means of useful and intelligent features such as: 1. Automated arrangement of spore counts into MySQL database. 2. Ability to retrieve, view and manipulate spore information utilizing any characteristic for the spore. 3. Ability to generate different graphical representations of the data instantaneously. 4. Ability to store and reference images. 6. Ability to relating the spores count with the weather factors.